-- SELECT xShortID, * FROM dbo.yt_tapd_task AS tt -- WHERE tt.xShortID = 1025460



IF NOT EXISTS(SELECT 1 FROM sys.tables AS t (NOLOCK) INNER JOIN sys.columns AS c (NOLOCK) ON c.object_id = t.object_id WHERE t.name = 'yt_tapd_task' AND c.name = 'xShortID')
BEGIN
		ALTER TABLE dbo.yt_tapd_task ADD xShortID AS sID % 10000000
END
GO

